package com.example.demo.mapper;

import com.example.demo.model.UserInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface UserInfoMapper {
    @Select("select id,user_name,password,github_Url " +
            " from user  " +
            "where user_name = #{userName} and delete_flag = 0")
    UserInfo selectByName(String userName);

    @Select("select id,user_name,password,github_Url " +
            " from blog  " +
            "where id = #{id} and delete_flag = 0")
    UserInfo selectById(Integer id);

}

